package com.ybwh.springboot2.sharding5.dao;

import com.gitee.fastmybatis.core.mapper.CrudMapper;
import com.ybwh.springboot2.sharding5.model.po.Report;
import org.apache.ibatis.annotations.Param;

import java.util.Collection;
import java.util.Date;
import java.util.List;

public interface ReportDao extends CrudMapper<Report/*实体类*/, Long/*主键类型*/> {


    List<Report> selectEqCreateTime(@Param("createTime") Date createTime);

    List<Report> selectInCreateTime(@Param("createTimeList") Collection<Date> createTimeList);

    List<Report> selectBetweenCreateTime(@Param("start") Date start, @Param("end") Date end);


    Integer selectCount(@Param("start") Date start, @Param("end") Date end);

    long selectSum(@Param("start") Date start, @Param("end") Date end);


}